🗄️ Database Design - hello · Scour

Inner vs Outer Joins: The Two Fundamental Join Types in SQL 🔗Join Algorithms

dev.to·23h·DEV

Beyond the SELECT: Mastering Advanced SQL for Surgical BI 🔍Query Optimization

dattasable.com·1d·DEV

Show HN: I built an SQL layer for a NoSQL database 🗄️Databases

news.ycombinator.com·5d·Hacker News

Using Polars Instead of Pandas: Performance Deep Dive ⚡Polars Expression API

kdnuggets.com·2h

Article: Time-Series Storage: Design Choices That Shape Cost and Performance 📈Time-Series Databases

Designing the Right PostgreSQL Index Using Query Plans and Statistics 🗺️PostgreSQL Planner

beh74.github.io·1d·DEV, Hacker News

Managed Postgres, Examined: Google Cloud SQL for PostgreSQL 🌐YugabyteDB

thebuild.com·3h

Improve DynamoDB analytics with AWS Glue zero-ETL schema and partition controls ⚡DynamoDB

aws.amazon.com·22h

PolySQL: Scaling Text-to-SQL Evaluation Across SQL Dialects via Automated Backend Isomorphism ⛽Diesel

My take on data quality: Tier 2 🔧Data Engineering

substackcdn.com·5d·Substack

Why Large-Scale Data Systems Break Quietly 💰TigerBeetle

hackernoon.com·13h

TabPFN-3: scaling foundation models for tabular data to 1M rows 🎨ART Trees

priorlabs.ai·3h·Hacker News

How we 40x'd the performance of a class of temporal queries 📈Time-Series Databases

Why Database-Layer Double-Entry Is a Bet, Not a Guarantee 💰TigerBeetle

news.alvaroduran.com

·6d

Kill the loading spinner with local-first data and reactive SQL ⚡Supabase

infoworld.com·7h

Strong views on PostgreSQL VIEWs 🐘PostgreSQL Internals

boringsql.com·2d·Hacker News

Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default 📦Binary Formats

freedevtool.org·3h·DEV

The SQL+JSON+Vector Triad: How I Built 3 AI-Powered Analytics Layers Without Writing a Single… 🔥DataFusion

pub.towardsai.net

·12h

Safe ZFS Tuning Practices for Production Databases 📋Columnar Storage

klarasystems.com·5d

Schema Markup: What It Is & How to Implement It 📋PartiQL

Log in to enable infinite scrolling